package com.bgs.travelapp.order.mapper;

import com.bgs.travelapp.mapper.BaseMapper;
import com.bgs.travelapp.order.entity.ScenicOrderEntity;
import org.apache.ibatis.annotations.*;

/**
 * fys 2022年8月4日11:02:47
 * 订单展示SQL
 */
@Mapper
public interface ScenicOrdersMapper extends BaseMapper<ScenicOrderEntity> {

    @Select("select sum(ticket_num) from scenic_order where scenic_id = #{scenicId}")
    Integer scenicStatistics(Integer scenicId);
}